Diagram Billing_Contract

Defincja diagramu Billing_Contract

Name

Billing_Contract

Code

Billing_Contract

Comment

Defines contract data


Lista tabel diagramu

Name

Code

Account

Account

AccountType

AccountType

AccountTypeText

AccountTypeText

ClinicalTrial

ClinicalTrial

Contract

Contract

ContractData

ContractData

Contractor

Contractor

ContractService

ContractService

ContractServicePointWeight

ContractServicePointWeight

ContractStatus

ContractStatus

ContractStatusText

ContractStatusText

Department

Department

DepartmentText

DepartmentText

DetailedContrSubject

DetailedContrSubject

DetailedContrSubjectText

DetailedContrSubjectText

LContractContract

LContractContract

LContractOrgUnitAccount

LContractOrgUnitAccount

LContractServContractServ

LContractServContractServ

LContractServService

LContractServService

ResourceItem

ResourceItem

Service

Service


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_56

R_56

Service

LContractServService

ServID

 

 

R_743

R_743

ContractService

LContractServContractServ

Con_ContractServID

 

 

R_744

R_744

ContractService

LContractServContractServ

ContractServID

 

 

R_845

R_845

Contract

LContractContract

Con_ContractID

 

 

R_846

R_846

Contract

LContractContract

ContractID

 

 

R_847

R_847

Contract

ContractData

ContractID

 

 

R_1004

R_1004

ContractService

ContractData

ContractServID

 

 

R_1780

R_1780

ContractStatus

ContractStatusText

ContractStatusID

 

 

R_8776

R_8776

Contract

LContractServService

ContractID

 

 

R_8777

R_8777

ResourceItem

LContractServService

ResourceID

 

 

R_8822

R_8822

Contract

ClinicalTrial

ContractID

 

 

R_9303

R_9303

AccountType

AccountTypeText

AccountTypeID

 

 

R_9304

R_9304

AccountType

Account

AccountTypeID

 

 

R_9305

R_9305

Account

Account

ParentAccountID

 

 

R_9306

R_9306

Contract

LContractOrgUnitAccount

ContractID

 

 

R_9308

R_9308

Account

LContractOrgUnitAccount

AccountID

 

 

R_10131

R_10131

DetailedContrSubject

DetailedContrSubjectText

DetailedContrSubjectID

 

 

R_10132

R_10132

DetailedContrSubject

Contract

DetailedContrSubjectID

 

 

R_10133

R_10133

Department

DepartmentText

DepartmentID

 

 

R_10134

R_10134

Department

Service

DepartmentID